home *** CD-ROM | disk | FTP | other *** search
/ Shareware Super Platinum 8 / Shareware Super Platinum 8.iso / mac / EDITORS / ADCONV60.ZIP;1 / LOTUS123.DOC < prev    next >
Encoding:
Text File  |  1994-02-14  |  12.1 KB  |  450 lines
  1. ================================================================
  2. LOTUS123.DOC
  3. ================================================================
  4.  
  5. This document deals with conversion of features from Lotus 1-2-3
  6. versions 2.01, 2.3, 2.4, 3.0, 3.1, and Lotus 1.0 for Windows to
  7. WordPerfect 6.0.  Currently, converting tables from WordPerfect
  8. 6.0 to Lotus 1-2-3 is not supported.
  9.  
  10.  
  11.  LOTUS 123 versions 1A, 2.01, 2.3,
  12.  2.4, 3.0, and 3.1
  13.  LOTUS 1.0 for Windows               WORDPERFECT 6.0
  14.  ======================              ===============
  15.  Format
  16.  
  17.       +/-                            Number Type Format: General
  18.  
  19.       Currency                       Number Type Format: Currency
  20.  
  21.       Date1                          Date Type Format: #4
  22.  
  23.       Date2                          Date Type Format: B
  24.  
  25.       Date3                          Date Type Format: #4
  26.  
  27.       Date4                          Date Type Format: #2
  28.  
  29.       Date5                          Date Type Format: A
  30.  
  31.       Fixed                          Number Type Format: Fixed
  32.  
  33.       General                        Number Type Format: General
  34.  
  35.       Hidden                         Hidden Text
  36.  
  37.       Other-Auto                     Not converted
  38.  
  39.       Other-Color-Neg                Not converted
  40.  
  41.       Other-Label                    Not converted
  42.  
  43.       Other-Paren-Y/N                Negative Numbers: Parenthesis
  44.  
  45.       Percent                        Number Type Format: Percent
  46.  
  47.       Row Height                     Not converted
  48.  
  49.       Scientific                     Number Type Format: Scientific
  50.  
  51.       Text                           Number Type Format: Text
  52.  
  53.       Time1                          Date Type Format: #6
  54.  
  55.       Time2                          Date Type Format: #6
  56.  
  57.       Time3                          Date Type Format: C
  58.  
  59.       Time4                          Date Type Format: C
  60.  
  61.  Label
  62.  
  63.       Left                           Converted to Left Justification
  64.                                      assigned to table cell
  65.  
  66.       Center                         Converted to Center
  67.                                      Justification assigned to table
  68.                                      cell
  69.  
  70.       Col-Width                      Column: Width #8
  71.  
  72.       Right                          Converted to Right
  73.                                      Justification assigned to table
  74.                                      cell
  75.  
  76.       Protection
  77.  
  78.            Disable                   Cell Lock (toggle)
  79.  
  80.            Enable                    Cell Lock
  81.  
  82.       Label                          Not converted
  83.  
  84.       Recalc                         Not converted
  85.  
  86.       Zero-No                        Not converted
  87.  
  88.       Zero-Yes                       Not converted
  89.  
  90.  DEFAULT
  91.  
  92.       Graphs                         Not converted
  93.  
  94.       OTHER-Int'l-ASCII              Not converted
  95.  
  96.       OTHER-Int'l-Currency-Prefix    Not converted
  97.  
  98.       OTHER-Int'l-Date A,B,C,D       Not converted
  99.  
  100.       OTHER-Int'l-File-Ts-           Not converted
  101.       Intern'tl
  102.  
  103.       OTHER-Int'l-File-Ts-Country    Not converted
  104.  
  105.       OTHER-Int'l-Negative-Parenth   Not converted
  106.  
  107.       OTHER-Int'l-PunctA-H           Not converted
  108.  
  109.       OTHER-Int'l-Rel-2LICS          Not converted
  110.  
  111.       OTHER-Int'l-Sign               Not converted
  112.  
  113.       OTHER-Int'l-Suffix             Not converted
  114.  
  115.       OTHER-Int'l-Time A,B,C,D       Not converted
  116.  
  117.       Printer-AutoLf-Yes/No          Not converted
  118.  
  119.       Printer-Bottom                 Bottom Margin
  120.  
  121.       Printer-Interfce               Not converted
  122.  
  123.       Printer-Left                   Left Margin
  124.  
  125.       Printer-Name                   Not converted
  126.  
  127.       Printer-Pg-Lgth                Not converted
  128.  
  129.       Printer-Right                  Right Margin
  130.  
  131.       Printer-Setup                  Not converted
  132.  
  133.       Printer-Top                    Top Margin
  134.  
  135.       Printer-Wait-Y/N               Not converted
  136.  
  137.  Column
  138.  
  139.       Hide                           Hidden
  140.  
  141.       Reset-Width                    Column Width: default
  142.  
  143.       Set-Wdth                       Column Width: #8
  144.  
  145.       Unhide                         Show all Hidden Text
  146.  
  147.  Titles
  148.  
  149.       Both                           Not converted
  150.  
  151.       Hortz                          Converts to a title heading on
  152.                                      each page
  153.  
  154.       Vert                           Not converted
  155.  
  156.       Clear                          Not converted
  157.  
  158.  Page                                Hard Page Break
  159.  
  160.  DATA
  161.  
  162.       Fill                           Convert to value or text
  163.  
  164.       Table                          Convert to value or text
  165.  
  166.            1 Input                   Convert to value or text
  167.  
  168.            2 Input                   Convert to value or text
  169.  
  170.            Reset                     Convert to value or text
  171.  
  172.       Distribution                   Convert to value or text
  173.  
  174.       Matrix-Invert                  Convert to value or text
  175.  
  176.       Multiply                       Convert to value or text
  177.  
  178.       Parse                          Convert to value or text
  179.  
  180.       Query                          Convert to value or text
  181.  
  182.       Regression                     Convert to value or text
  183.  
  184.       Sort                           Convert to value or text
  185.  
  186.  Range
  187.  
  188.       Erase                          Not converted
  189.  
  190.       Justify                        Not converted
  191.  
  192.       Name                           Range Names convert
  193.  
  194.       Protect                        Cell: Lock
  195.  
  196.       Unprotect                      Cell: Lock (toggle)
  197.  
  198.  Database Function
  199.  
  200.       DAVG()                         Not converted
  201.  
  202.       DCOUNT()                       Not converted
  203.  
  204.       DGET()                         Not converted
  205.  
  206.       DMAX()                         Not converted
  207.  
  208.       DMIN()                         Not converted
  209.  
  210.       DQUERY()                       Not converted
  211.  
  212.       DSTD()                         Not converted
  213.  
  214.       DSTDS()                        Not converted
  215.  
  216.       DSUM()                         Not converted
  217.  
  218.       DVAR()                         Not converted
  219.  
  220.       DVARS()                        Not converted
  221.  
  222.  Date and Time Function
  223.  
  224.       D360()                         Not converted
  225.  
  226.       DATE()                         DATE()
  227.  
  228.       DATEVALUE()                    DATEVALUE()
  229.  
  230.       DAY()                          DAY()
  231.  
  232.       HOUR()                         HOUR()
  233.  
  234.       MINUTE()                       MINUTE()
  235.  
  236.       MONTH()                        MONTH()
  237.  
  238.       NOW()                          MDY()+HMS()
  239.  
  240.       SECOND()                       SECOND()
  241.  
  242.       TIME()                         TIME()
  243.  
  244.       TIMEVALUE()                    TIMEVALUE()
  245.  
  246.       TODAY ()                       MDY()
  247.  
  248.       YEAR()                         YEAR()
  249.  
  250.  Financial Function
  251.  
  252.       CTERM()                        TERM()
  253.  
  254.       DDB()                          DDB()
  255.  
  256.       FV()                           FV()
  257.  
  258.       IRR()                          IRR()
  259.  
  260.       NPV()                          NPV()
  261.  
  262.       PMT()                          PMT()
  263.  
  264.       PV()                           PV()
  265.  
  266.       RATE()                         RATE()
  267.  
  268.       SLN()                          SLN()
  269.  
  270.       SYD()                          SYD()
  271.  
  272.       TERM()                         TERM()
  273.  
  274.       VDB()                          Not converted
  275.  
  276.  Logical Function
  277.  
  278.       FALSE()                        FALSE()
  279.  
  280.       IF()                           IF()
  281.  
  282.       ISERR()                        ISERR()
  283.  
  284.       ISNA()                         ISNA()
  285.  
  286.       ISNUMBER()                     ISVALUE()
  287.  
  288.       ISRANGE()                      Not converted
  289.  
  290.       ISSTRING()                     ISTEXT()
  291.  
  292.       TRUE()                         TRUE()
  293.  
  294.  Mathematical Function
  295.  
  296.       ABS()                          ABS()
  297.  
  298.       ACOS()                         ACOS()
  299.  
  300.       ASIN()                         ASIN()
  301.  
  302.       ATAN()                         ATAN()
  303.  
  304.       ATAN2()                        ATAN2()
  305.  
  306.       COS()                          COS()
  307.  
  308.       EXP()                          EXP()
  309.  
  310.       INT()                          INT()
  311.  
  312.       LN()                           LN()
  313.  
  314.       LOG()                          LOG()
  315.  
  316.       MOD()                          MOD()
  317.  
  318.       PI()                           PI()
  319.  
  320.       RAND()                         RANDOM()
  321.  
  322.       ROUND()                        ROUND()
  323.  
  324.       SIN()                          SIN()
  325.  
  326.       SQRT()                         SQRT()
  327.  
  328.       TAN()                          TAN()
  329.  
  330.  Special Function
  331.  
  332.       @@()                           Not converted
  333.  
  334.       CELL()                         Not converted
  335.  
  336.       CELLPOINTER()                  Not converted
  337.  
  338.       CHOOSE()                       CHOOSE()
  339.  
  340.       COLS()                         Not converted
  341.  
  342.       COORD()                        Not converted
  343.  
  344.       ERR()                          Not converted
  345.  
  346.       HLOOKUP()                      LOOKUP()
  347.  
  348.       INDEX()                        INDEX()
  349.  
  350.       INFO()                         Not converted
  351.  
  352.       NA()                           NA()
  353.  
  354.       ROWS()                         Not converted
  355.  
  356.       SHEETS()                       Not converted
  357.  
  358.       VLOOKUP()                      LOOKUP()
  359.  
  360.  Statistical Function
  361.  
  362.       AVG()                          AVE()
  363.  
  364.       COUNT()                        COUNT()
  365.  
  366.       MAX()                          MAX()
  367.  
  368.       MIN()                          MIN()
  369.  
  370.       STD()                          STDEV()
  371.  
  372.       STDS()                         STDEV()
  373.  
  374.       SUM()                          SUM()
  375.  
  376.       SUMPRODUCT()                   Not converted
  377.  
  378.       VAR()                          VAR()
  379.  
  380.       VARS()                         VAR()
  381.  
  382.  String Function
  383.  
  384.       CHAR()                         CHAR()
  385.  
  386.       CODE()                         Not converted
  387.  
  388.       EXACT()                        Not converted
  389.  
  390.       FIND()                         Not converted
  391.  
  392.       LEFT()                         LEFT()
  393.  
  394.       LENGTH()                       LENGTH()
  395.  
  396.       LOWER()                        LOWER()
  397.  
  398.       MID()                          MID()
  399.  
  400.       N()                            Not converted
  401.  
  402.       PROPER()                       PROPER()
  403.  
  404.       REPEAT()                       REPEAT()
  405.  
  406.       REPLACE()                      Not converted
  407.  
  408.       RIGHT()                        RIGHT()
  409.  
  410.       S()                            Not converted
  411.  
  412.       STRING()                       TEXT()
  413.  
  414.       TRIM()                         Not converted
  415.  
  416.       UPPER()                        UPPER()
  417.  
  418.       VALUE()                        VALUE()
  419.  
  420.  
  421. Negative numbers that have parentheses set as the negative
  422. indicator convert with a minus sign (-) indicator with the minus
  423. sign between the $ sign for currency and the number.  For
  424. example, the number ($45.00) would convert to $-45.00.
  425.  
  426. Importing spreadsheets up to 64 columns is supported.  If you try
  427. to import a spreadsheet with more than 64 columns, all columns
  428. after the 64th column are truncated.
  429.  
  430. Importing a spreadsheet into a WordPerfect 6.0 document changes
  431. the Table Line defaults for all following tables to "None." 
  432. Tables following the imported spreadsheet will need to be edited
  433. and changed to restore the table lines and borders.
  434.  
  435. Spreadsheets formatted for printing using the WYSIWYG feature of
  436. Lotus will not retain that formatting as the formatting is stored
  437. in a file separate from the spreadsheet file.
  438.  
  439. Fonts 1 through 8 of DOS versions of Lotus will convert when the
  440. spreadsheet has not been formatted with WYSIWYG.  Fonts in Lotus
  441. 1-2-3 for Windows spreadsheets will not convert as they are
  442. stored in a file separate from the spreadsheet file.
  443.  
  444. Hidden columns will convert to a column width of .001.  Changing
  445. the column width in WordPerfect 6.0 will expand hidden columns 
  446. and turning on the 'Show All Hidden Text' option will allow the
  447. data in each table cell to be viewed.
  448.  
  449. Functions not supported in WordPerfect 6.0 tables will convert as
  450. the calculated value of that function.